package com.cnswhy.cloud.server.core.dao;

import com.cnswhy.cloud.common.core.base.mapper.SuperMapper;
import com.cnswhy.cloud.server.common.entity.enumeration.WalletType;
import com.cnswhy.cloud.server.core.entity.CustomerWithdrawalRecord;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * <p>
 * Mapper 接口
 * 
 * </p>
 *
 * @author cnswhy
 * @date 2020-10-14
 */
@Repository
public interface CustomerWithdrawalRecordMapper extends SuperMapper<CustomerWithdrawalRecord> {
    @Select("select ifnull(sum(t.sett_amt),0) from t_customer_withdrawal_record t where sett_date = #{settDate} and status = 2")
    Long getSumWithdrawAmtBySettDate(@Param("settDate") String settDate);

}
